<If Loop>
   <IsFKey>
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
   <ExitLoop>
</If Loop>

<If Loop>
   <IsFKey>
public class <OwnerU>_<TableU>_<ROwnerU>_<RTableU>DataClass<MiscTag>
{
    public static List<<OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>> List()
    {
        List<<OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>> <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List = new List<<OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>>();
        SqlConnection connection = <Database>DataClass.GetConnection();
        String selectProcedure = "[<Owner>].[<TableU>_<RTableU><MiscTag>Select]";
        SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
        try
        {
            connection.Open();
            SqlDataReader reader = selectCommand.ExecuteReader();
            <OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag> cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU> = new <OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>();
            while (reader.Read())
            {
                cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU> = new <OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>();
                <IsFKey>
                cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU>.<RFieldU> = <Convert>(reader["<RField>"]);
                <IsFKey>
                <And>
                <IsRDisplayField>
                cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU>.<RDisplayFieldU> = Convert.ToString(reader["<RDisplayField>"]);
                <IsFKey>
                <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List.Add(cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU>);
            <IsFKey>
            }
            reader.Close();
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
        return <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List;
    }

}

</If Loop>

